﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AllowanceApplicationForm" targetNamespace="http://tempuri.org/AllowanceApplicationForm.xsd" xmlns:mstns="http://tempuri.org/AllowanceApplicationForm.xsd" xmlns="http://tempuri.org/AllowanceApplicationForm.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ElingOA5_Admin_DaXieConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ElingOA5_Admin_DaXieConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ElingOA5_Admin_DaXieConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="t_AllowanceApplicationFormTableAdapter" GeneratorDataComponentClassName="t_AllowanceApplicationFormTableAdapter" Name="t_AllowanceApplicationForm" UserDataComponentName="t_AllowanceApplicationFormTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ElingOA5_Admin_DaXieConnectionString (Web.config)" DbObjectName="ElingOA5_Admin_DaXie.fund.t_AllowanceApplicationForm" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [fund].[t_AllowanceApplicationForm] WHERE (([FApplicationFormID] = @Original_FApplicationFormID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FApplicationFormID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FApplicationFormID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [fund].[t_AllowanceApplicationForm] ([FApplicationFormID], [FSource], [FSourceNo], [FStatus], [NSRDZDAH], [NSRMC], [YHZK], [KHYH], [FFileNo], [FNote], [FIsReturn], [FFinancePropNo], [FYear], [FApplyAmount], [FAuditAmount], [FApplyName], [FApplyDate], [FEntityNo], [FInsEmpNo], [FInsDeptNo], [FInsDate], [FInsIP], [FUpdEmplNo], [FUpdDeptNo], [FUpdDate], [FUpdIP]) VALUES (@FApplicationFormID, @FSource, @FSourceNo, @FStatus, @NSRDZDAH, @NSRMC, @YHZK, @KHYH, @FFileNo, @FNote, @FIsReturn, @FFinancePropNo, @FYear, @FApplyAmount, @FAuditAmount, @FApplyName, @FApplyDate, @FEntityNo, @FInsEmpNo, @FInsDeptNo, @FInsDate, @FInsIP, @FUpdEmplNo, @FUpdDeptNo, @FUpdDate, @FUpdIP)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FApplicationFormID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FApplicationFormID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FSource" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FSource" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FSourceNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FSourceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NSRDZDAH" Precision="20" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NSRDZDAH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NSRMC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NSRMC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@YHZK" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="YHZK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KHYH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KHYH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FFileNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FFileNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FNote" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FNote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FIsReturn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIsReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FFinancePropNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FFinancePropNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FYear" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FYear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FApplyAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FApplyAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FAuditAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FAuditAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FApplyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FApplyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FApplyDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FApplyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FEntityNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FEntityNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FInsEmpNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FInsEmpNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FInsDeptNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FInsDeptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FInsDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FInsDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FInsIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FInsIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FUpdEmplNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FUpdEmplNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FUpdDeptNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FUpdDeptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FUpdDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FUpdDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FUpdIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FUpdIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT FApplicationFormID, FSource, FSourceNo, FStatus, NSRDZDAH, NSRMC, YHZK, KHYH, FFileNo, FNote, FIsReturn, FFinancePropNo, FYear, FApplyAmount, FAuditAmount, FApplyName, FApplyDate, FEntityNo, FInsEmpNo, FInsDeptNo, FInsDate, FInsIP, FUpdEmplNo, FUpdDeptNo, FUpdDate, FUpdIP FROM fund.t_AllowanceApplicationForm</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [fund].[t_AllowanceApplicationForm] SET [FApplicationFormID] = @FApplicationFormID, [FSource] = @FSource, [FSourceNo] = @FSourceNo, [FStatus] = @FStatus, [NSRDZDAH] = @NSRDZDAH, [NSRMC] = @NSRMC, [YHZK] = @YHZK, [KHYH] = @KHYH, [FFileNo] = @FFileNo, [FNote] = @FNote, [FIsReturn] = @FIsReturn, [FFinancePropNo] = @FFinancePropNo, [FYear] = @FYear, [FApplyAmount] = @FApplyAmount, [FAuditAmount] = @FAuditAmount, [FApplyName] = @FApplyName, [FApplyDate] = @FApplyDate, [FEntityNo] = @FEntityNo, [FInsEmpNo] = @FInsEmpNo, [FInsDeptNo] = @FInsDeptNo, [FInsDate] = @FInsDate, [FInsIP] = @FInsIP, [FUpdEmplNo] = @FUpdEmplNo, [FUpdDeptNo] = @FUpdDeptNo, [FUpdDate] = @FUpdDate, [FUpdIP] = @FUpdIP WHERE (([FApplicationFormID] = @Original_FApplicationFormID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FApplicationFormID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FApplicationFormID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FSource" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FSource" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FSourceNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FSourceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NSRDZDAH" Precision="20" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NSRDZDAH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NSRMC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NSRMC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@YHZK" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="YHZK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KHYH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KHYH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FFileNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FFileNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FNote" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FNote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FIsReturn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIsReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FFinancePropNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FFinancePropNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FYear" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FYear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FApplyAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FApplyAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FAuditAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FAuditAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FApplyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FApplyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FApplyDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FApplyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FEntityNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FEntityNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FInsEmpNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FInsEmpNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FInsDeptNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FInsDeptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FInsDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FInsDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FInsIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FInsIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FUpdEmplNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FUpdEmplNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FUpdDeptNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FUpdDeptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FUpdDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FUpdDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FUpdIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FUpdIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FApplicationFormID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FApplicationFormID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FApplicationFormID" DataSetColumn="FApplicationFormID" />
              <Mapping SourceColumn="FSource" DataSetColumn="FSource" />
              <Mapping SourceColumn="FSourceNo" DataSetColumn="FSourceNo" />
              <Mapping SourceColumn="FStatus" DataSetColumn="FStatus" />
              <Mapping SourceColumn="NSRDZDAH" DataSetColumn="NSRDZDAH" />
              <Mapping SourceColumn="NSRMC" DataSetColumn="NSRMC" />
              <Mapping SourceColumn="YHZK" DataSetColumn="YHZK" />
              <Mapping SourceColumn="KHYH" DataSetColumn="KHYH" />
              <Mapping SourceColumn="FFileNo" DataSetColumn="FFileNo" />
              <Mapping SourceColumn="FNote" DataSetColumn="FNote" />
              <Mapping SourceColumn="FIsReturn" DataSetColumn="FIsReturn" />
              <Mapping SourceColumn="FFinancePropNo" DataSetColumn="FFinancePropNo" />
              <Mapping SourceColumn="FYear" DataSetColumn="FYear" />
              <Mapping SourceColumn="FApplyAmount" DataSetColumn="FApplyAmount" />
              <Mapping SourceColumn="FAuditAmount" DataSetColumn="FAuditAmount" />
              <Mapping SourceColumn="FApplyName" DataSetColumn="FApplyName" />
              <Mapping SourceColumn="FApplyDate" DataSetColumn="FApplyDate" />
              <Mapping SourceColumn="FEntityNo" DataSetColumn="FEntityNo" />
              <Mapping SourceColumn="FInsEmpNo" DataSetColumn="FInsEmpNo" />
              <Mapping SourceColumn="FInsDeptNo" DataSetColumn="FInsDeptNo" />
              <Mapping SourceColumn="FInsDate" DataSetColumn="FInsDate" />
              <Mapping SourceColumn="FInsIP" DataSetColumn="FInsIP" />
              <Mapping SourceColumn="FUpdEmplNo" DataSetColumn="FUpdEmplNo" />
              <Mapping SourceColumn="FUpdDeptNo" DataSetColumn="FUpdDeptNo" />
              <Mapping SourceColumn="FUpdDate" DataSetColumn="FUpdDate" />
              <Mapping SourceColumn="FUpdIP" DataSetColumn="FUpdIP" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AllowanceApplicationForm" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="AllowanceApplicationForm" msprop:Generator_UserDSName="AllowanceApplicationForm">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="t_AllowanceApplicationForm" msprop:Generator_TableClassName="t_AllowanceApplicationFormDataTable" msprop:Generator_TableVarName="tablet_AllowanceApplicationForm" msprop:Generator_TablePropName="t_AllowanceApplicationForm" msprop:Generator_RowDeletingName="t_AllowanceApplicationFormRowDeleting" msprop:Generator_RowChangingName="t_AllowanceApplicationFormRowChanging" msprop:Generator_RowEvHandlerName="t_AllowanceApplicationFormRowChangeEventHandler" msprop:Generator_RowDeletedName="t_AllowanceApplicationFormRowDeleted" msprop:Generator_UserTableName="t_AllowanceApplicationForm" msprop:Generator_RowChangedName="t_AllowanceApplicationFormRowChanged" msprop:Generator_RowEvArgName="t_AllowanceApplicationFormRowChangeEvent" msprop:Generator_RowClassName="t_AllowanceApplicationFormRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FApplicationFormID" msprop:Generator_ColumnVarNameInTable="columnFApplicationFormID" msprop:Generator_ColumnPropNameInRow="FApplicationFormID" msprop:Generator_ColumnPropNameInTable="FApplicationFormIDColumn" msprop:Generator_UserColumnName="FApplicationFormID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FSource" msprop:Generator_ColumnVarNameInTable="columnFSource" msprop:Generator_ColumnPropNameInRow="FSource" msprop:Generator_ColumnPropNameInTable="FSourceColumn" msprop:Generator_UserColumnName="FSource" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FSourceNo" msprop:Generator_ColumnVarNameInTable="columnFSourceNo" msprop:Generator_ColumnPropNameInRow="FSourceNo" msprop:Generator_ColumnPropNameInTable="FSourceNoColumn" msprop:Generator_UserColumnName="FSourceNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FStatus" msprop:Generator_ColumnVarNameInTable="columnFStatus" msprop:Generator_ColumnPropNameInRow="FStatus" msprop:Generator_ColumnPropNameInTable="FStatusColumn" msprop:Generator_UserColumnName="FStatus">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NSRDZDAH" msprop:Generator_ColumnVarNameInTable="columnNSRDZDAH" msprop:Generator_ColumnPropNameInRow="NSRDZDAH" msprop:Generator_ColumnPropNameInTable="NSRDZDAHColumn" msprop:Generator_UserColumnName="NSRDZDAH" type="xs:decimal" minOccurs="0" />
              <xs:element name="NSRMC" msprop:Generator_ColumnVarNameInTable="columnNSRMC" msprop:Generator_ColumnPropNameInRow="NSRMC" msprop:Generator_ColumnPropNameInTable="NSRMCColumn" msprop:Generator_UserColumnName="NSRMC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="YHZK" msprop:Generator_ColumnVarNameInTable="columnYHZK" msprop:Generator_ColumnPropNameInRow="YHZK" msprop:Generator_ColumnPropNameInTable="YHZKColumn" msprop:Generator_UserColumnName="YHZK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KHYH" msprop:Generator_ColumnVarNameInTable="columnKHYH" msprop:Generator_ColumnPropNameInRow="KHYH" msprop:Generator_ColumnPropNameInTable="KHYHColumn" msprop:Generator_UserColumnName="KHYH" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FFileNo" msprop:Generator_ColumnVarNameInTable="columnFFileNo" msprop:Generator_ColumnPropNameInRow="FFileNo" msprop:Generator_ColumnPropNameInTable="FFileNoColumn" msprop:Generator_UserColumnName="FFileNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FNote" msprop:Generator_ColumnVarNameInTable="columnFNote" msprop:Generator_ColumnPropNameInRow="FNote" msprop:Generator_ColumnPropNameInTable="FNoteColumn" msprop:Generator_UserColumnName="FNote" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FIsReturn" msprop:Generator_ColumnVarNameInTable="columnFIsReturn" msprop:Generator_ColumnPropNameInRow="FIsReturn" msprop:Generator_ColumnPropNameInTable="FIsReturnColumn" msprop:Generator_UserColumnName="FIsReturn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FFinancePropNo" msprop:Generator_ColumnVarNameInTable="columnFFinancePropNo" msprop:Generator_ColumnPropNameInRow="FFinancePropNo" msprop:Generator_ColumnPropNameInTable="FFinancePropNoColumn" msprop:Generator_UserColumnName="FFinancePropNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FYear" msprop:Generator_ColumnVarNameInTable="columnFYear" msprop:Generator_ColumnPropNameInRow="FYear" msprop:Generator_ColumnPropNameInTable="FYearColumn" msprop:Generator_UserColumnName="FYear" type="xs:decimal" minOccurs="0" />
              <xs:element name="FApplyAmount" msprop:Generator_ColumnVarNameInTable="columnFApplyAmount" msprop:Generator_ColumnPropNameInRow="FApplyAmount" msprop:Generator_ColumnPropNameInTable="FApplyAmountColumn" msprop:Generator_UserColumnName="FApplyAmount" type="xs:decimal" />
              <xs:element name="FAuditAmount" msprop:Generator_ColumnVarNameInTable="columnFAuditAmount" msprop:Generator_ColumnPropNameInRow="FAuditAmount" msprop:Generator_ColumnPropNameInTable="FAuditAmountColumn" msprop:Generator_UserColumnName="FAuditAmount" type="xs:decimal" />
              <xs:element name="FApplyName" msprop:Generator_ColumnVarNameInTable="columnFApplyName" msprop:Generator_ColumnPropNameInRow="FApplyName" msprop:Generator_ColumnPropNameInTable="FApplyNameColumn" msprop:Generator_UserColumnName="FApplyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FApplyDate" msprop:Generator_ColumnVarNameInTable="columnFApplyDate" msprop:Generator_ColumnPropNameInRow="FApplyDate" msprop:Generator_ColumnPropNameInTable="FApplyDateColumn" msprop:Generator_UserColumnName="FApplyDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FEntityNo" msprop:Generator_ColumnVarNameInTable="columnFEntityNo" msprop:Generator_ColumnPropNameInRow="FEntityNo" msprop:Generator_ColumnPropNameInTable="FEntityNoColumn" msprop:Generator_UserColumnName="FEntityNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FInsEmpNo" msprop:Generator_ColumnVarNameInTable="columnFInsEmpNo" msprop:Generator_ColumnPropNameInRow="FInsEmpNo" msprop:Generator_ColumnPropNameInTable="FInsEmpNoColumn" msprop:Generator_UserColumnName="FInsEmpNo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FInsDeptNo" msprop:Generator_ColumnVarNameInTable="columnFInsDeptNo" msprop:Generator_ColumnPropNameInRow="FInsDeptNo" msprop:Generator_ColumnPropNameInTable="FInsDeptNoColumn" msprop:Generator_UserColumnName="FInsDeptNo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FInsDate" msprop:Generator_ColumnVarNameInTable="columnFInsDate" msprop:Generator_ColumnPropNameInRow="FInsDate" msprop:Generator_ColumnPropNameInTable="FInsDateColumn" msprop:Generator_UserColumnName="FInsDate" type="xs:dateTime" />
              <xs:element name="FInsIP" msprop:Generator_ColumnVarNameInTable="columnFInsIP" msprop:Generator_ColumnPropNameInRow="FInsIP" msprop:Generator_ColumnPropNameInTable="FInsIPColumn" msprop:Generator_UserColumnName="FInsIP">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FUpdEmplNo" msprop:Generator_ColumnVarNameInTable="columnFUpdEmplNo" msprop:Generator_ColumnPropNameInRow="FUpdEmplNo" msprop:Generator_ColumnPropNameInTable="FUpdEmplNoColumn" msprop:Generator_UserColumnName="FUpdEmplNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FUpdDeptNo" msprop:Generator_ColumnVarNameInTable="columnFUpdDeptNo" msprop:Generator_ColumnPropNameInRow="FUpdDeptNo" msprop:Generator_ColumnPropNameInTable="FUpdDeptNoColumn" msprop:Generator_UserColumnName="FUpdDeptNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FUpdDate" msprop:Generator_ColumnVarNameInTable="columnFUpdDate" msprop:Generator_ColumnPropNameInRow="FUpdDate" msprop:Generator_ColumnPropNameInTable="FUpdDateColumn" msprop:Generator_UserColumnName="FUpdDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FDDBRMC" msprop:Generator_ColumnVarNameInTable="columnFDDBRMC" msprop:Generator_ColumnPropNameInRow="FDDBRMC" msprop:Generator_ColumnPropNameInTable="FDDBRMCColumn" msprop:Generator_UserColumnName="FDDBRMC" type="xs:string" minOccurs="0" />
              <xs:element name="FFinancePropName" msprop:Generator_ColumnVarNameInTable="columnFFinancePropName" msprop:Generator_ColumnPropNameInRow="FFinancePropName" msprop:Generator_ColumnPropNameInTable="FFinancePropNameColumn" msprop:Generator_UserColumnName="FFinancePropName" type="xs:string" minOccurs="0" />
              <xs:element name="FUpdIP" msprop:Generator_ColumnVarNameInTable="columnFUpdIP" msprop:Generator_ColumnPropNameInRow="FUpdIP" msprop:Generator_ColumnPropNameInTable="FUpdIPColumn" msprop:Generator_UserColumnName="FUpdIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FApplyAmountDX" msprop:Generator_ColumnVarNameInTable="columnFApplyAmountDX" msprop:Generator_ColumnPropNameInRow="FApplyAmountDX" msprop:Generator_ColumnPropNameInTable="FApplyAmountDXColumn" msprop:Generator_UserColumnName="FApplyAmountDX" type="xs:string" minOccurs="0" />
              <xs:element name="FAuditAmountDX" msprop:Generator_ColumnVarNameInTable="columnFAuditAmountDX" msprop:Generator_ColumnPropNameInRow="FAuditAmountDX" msprop:Generator_ColumnPropNameInTable="FAuditAmountDXColumn" msprop:Generator_UserColumnName="FAuditAmountDX" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:t_AllowanceApplicationForm" />
      <xs:field xpath="mstns:FApplicationFormID" />
    </xs:unique>
  </xs:element>
</xs:schema>